 
<!DOCTYPE html>
<html>
<head>
	<meta charset="UTF-8">
	<title>销售汇总日报</title>
	<link rel="stylesheet" type="text/css" href="../../rs/plugins/easyui/themes/metro/easyui.css">
	<link rel="stylesheet" type="text/css" href="../../rs/plugins/easyui/themes/icon.css">
	<link href="../../rs/css/bootstrap.min.css" rel="stylesheet">
	<link href="../../rs/css/style.min862f.css" rel="stylesheet">
	<link href="../../rs/plugins/datapicker/datepicker3.css" rel="stylesheet">
	<script type="text/javascript" src="../../rs/plugins/easyui/jquery.min.js"></script>
	<script type="text/javascript" src="../../rs/plugins/easyui/jquery.easyui.min.js"></script>
	<script type="text/javascript" src="../../rs/plugins/easyui/locale/easyui-lang-zh_CN.js"></script>
	<script type="text/javascript" src="../../rs/plugins/easyui/datagrid-groupview.js"></script>
	<script src="../../rs/js/jquery.cookie.js"></script>
	<script src="../../rs/js/common_qj.js"></script>
	<style>
		html,body{ margin:0px; height:100%;}
	</style>
	<?php
  		require_once('login.php');
 	?>
</head>
<body >
<table id="table" class="easyui-datagrid"  style="width:100%;height:100%;padding: 10px;"
	   data-options="
			rownumbers:true,
			singleSelect:'false',
			method:'get' ,
			toolbar:'#easyui_toolbar',
			fit:true,
			fitColumns:true,
	        fit:'true',
	        showFooter:true,
	        collapsible:true,
			view:groupview,
			groupField:'门店',
			groupFormatter:function(value,rows){return value + ' ('+my(rows)+')';}
	        ">
	<thead>
	<tr>
		<th data-options="field:'门店',width:60">门店</th>
		<th data-options="field:'编号',width:60">编号</th>
		<th data-options="field:'品名',width:100">品名</th>
		<th data-options="field:'数量',width:50,align:'right'">数量</th>
		<th data-options="field:'金额',width:70,align:'right'">金额</th>
	</tr>
	</thead>
</table>

<div id="easyui_toolbar" region="north" border="false"
	 style="height: 45px;padding: 5px 5px; ">

	<div style="float:left;">
		<button onClick="expert_excel1()" class="btn dropdown-toggle"  style=" border-radius: 0px; height:34px" type="button"  >
			<i class="glyphicon glyphicon-export icon-share"></i>
		</button>
	</div>
	<div class="col-sm-4">

		<div   id="data_5">
			<div class="input-daterange input-group" id="datepicker">
				<input style="height:34px" type="text" class="input-sm form-control" name="start" value="" id="start" />
				<span style="background: #E5E6E7;" class="input-group-addon">到</span>
				<input style="height:34px" type="text" class="input-sm form-control" name="end" value=""  id="end"/>
			</div>
		</div>
	</div>

	<div id="tb" class="input-group" style="float: right; margin-right: 10px;width:50px">
		<div class="input-group-btn">
			<button type="button" class="btn" onclick="do_search()" style="margin-left: 8px;
		border-radius:0px;">
				执行
			</button>
		</div>
	</div>
</div>


<!--页面加载缓冲图标-->
<div id='loadingDiv' style="position:absolute;z-index:1000;top:0px; left:0px;
	width:100%;height:100%;background:white;text-align: center;">
	<h1 style="top: 30%; position: relative;">
		<img src="../../rs/img/loading-2.gif" /><br>
	</h1>
</div>
<script src="../../rs/plugins/datapicker/bootstrap-datepicker.js"></script>
<script>

	/*页面加载缓冲*/
	function closeLoading() {
		$("#loadingDiv").fadeOut("normal", function () {
			$(this).remove();
		});
	}
	var no;
	$.parser.onComplete = function () {
		if (no) clearTimeout(no);
		no = setTimeout(closeLoading, 1000);
	}

	var sign = URLencode($.cookie('sign'));

	//    日期插件js开始
	$("#data_5 .input-daterange").datepicker({keyboardNavigation: !1, forceParse: !1, autoclose: !0});
	var config = {
		".chosen-select": {},
		".chosen-select-deselect": {allow_single_deselect: !0},
		".chosen-select-no-single": {disable_search_threshold: 10},
		".chosen-select-no-results": {no_results_text: "Oops, nothing found!"},
		".chosen-select-width": {width: "95%"}
	};
	//    日期插件js结束




	$(function(){
		if(sign==="undefined"){
			window.location.href = "login.html";
		}
		if ((new Date()).format('dd')==01)
		{var start1=(new Date()).format('dd');
		}else{
			var start1=(new Date()).format('dd')-1;
		}
		var start1=start1.toString();
		if (start1.length == 1) {
			start1 = '0' + start1;
		}
		var start=(new Date()).format('yyyy-MM-'+start1);
		var end=(new Date()).format( 'yyyy-MM-dd');
		$('#start').val(start);
		$('#end').val(end);
		/*f_sheard();*/
	});




	//判断用户权限&加载数据
	function f_sheard(){
		var rq1=$('#start').val();
		var rq2=$('#end').val();
		$.ajax({
			type: "post",
			url:G_url+'repo/shopxsrb',
			data:'sign=' + sign+"&rq1="+rq1+"&rq2="+rq2,
			dataType: "json",
			success: function (data){
				$('#table').datagrid({
					data: data
				});

			},
			error: function (XMLHttpRequest, textStatus, errorThrown) {
			}
		});
	}



	function do_search(){
		var rq1=$('#start').val();
		var rq2=$('#end').val();
		layer.msg('数据加载中...', {icon: 16, time: 200000, shade: [0.1, 'black']});
		$.ajax({
			type: "post",
			url:G_url+'repo/shopxsrb'+'?sign='+sign,
			data:"rq1="+rq1+"&rq2="+rq2,
			dataType: "json",
			success: function (result){
				$('#table').datagrid({
					data: result
				});
				layer.closeAll();
			},
			error: function (XMLHttpRequest, textStatus, errorThrown) {
				//alert(errorThrown);
			}
		});

	}


	function my(a){
		var  re;
		var r=0;
		for (var i=0;i<a.length ;i++ )
		{
			r=parseFloat(a[i].数量)+r;
		}
		r=r.toFixed(2);
		re=' 数量:'+ r;
		r=0;
		for (var i=0;i<a.length ;i++ )
		{
			r=parseFloat(a[i].金额)+r;
		}
		r=r.toFixed(2);
		re=re+' 金额:'+ r;
		return  re;
	}

</script>

<script src="../../rs/plugins/layer/layer.min.js"></script>
<script src="../../rs/js/bootstrap.js"></script>
<script src="../../rs/plugins/md5.js"></script>
<script src="../../rs/plugins/tableExport.js"></script>
<script>
	function expert_excel1(){
		for(var i=0;i<$(".datagrid-view2 .datagrid-btable").length;i++){

			newtable=$(".datagrid-view2").find(".datagrid-btable").eq(i).append('<table id="#newtable"+i+"">' +$("#table").html()+ '</table>');
			newtable.tableExport({
				type:'excel',
				separator:';',
				escape:'false'
			});
			$("#newtable"+i+"").remove();
		}
	}
</script>
</body>
</html>
